123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528 |
- <?xml version="1.0" encoding="UTF-8"?>
- <DocRoot>
- <Parameters/>
- <DataSources>
- <Reference name="AssureBillTDQuery" alias.zh_TW="擔保單" alias.zh_CN="担保单" alias.en="Guarantee Note" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" info="AssureBillTDQuery.bos-query">
- <Sorts>
- <Sort field="billId" type="ascend"/>
- </Sorts>
- </Reference>
- </DataSources>
- <Styles version="1.0">
- <Style id="15">
- <Borders>
- <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="top" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000"/>
- </Borders>
- <Alignment wrapText="true"/>
- <NumberFormat>yyyy-m-d</NumberFormat>
- </Style>
- <Style id="13">
- <Borders>
- <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="top" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000"/>
- </Borders>
- <Alignment wrapText="true"/>
- </Style>
- <Style id="14">
- <Borders>
- <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="top" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000"/>
- </Borders>
- <Alignment wrapText="true"/>
- <NumberFormat>yyyy-MM-dd h:mm:ss</NumberFormat>
- </Style>
- <Style id="11">
- <Borders>
- <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="top" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000"/>
- </Borders>
- <Alignment wrapText="false"/>
- <NumberFormat>0.00;-0.00</NumberFormat>
- </Style>
- <Style id="12">
- <Borders>
- <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="top" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000"/>
- </Borders>
- <Alignment horizontal="left" wrapText="false"/>
- </Style>
- <Style id="3">
- <Alignment wrapText="false"/>
- </Style>
- <Style id="2">
- <Borders>
- <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="top" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000"/>
- </Borders>
- </Style>
- <Style id="1"/>
- <Style id="10">
- <Borders>
- <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="top" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000"/>
- </Borders>
- <Alignment wrapText="false"/>
- <NumberFormat>0.000;-0.000</NumberFormat>
- </Style>
- <Style id="0">
- <Alignment wrapText="true"/>
- </Style>
- <Style id="7">
- <Borders>
- <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="top" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000"/>
- </Borders>
- <Alignment wrapText="false"/>
- </Style>
- <Style id="6">
- <Borders>
- <Border position="left" lineStyle="NullLine"/>
- </Borders>
- </Style>
- <Style id="5">
- <Borders>
- <Border position="left" lineStyle="NullLine"/>
- <Border position="right" lineStyle="NullLine"/>
- </Borders>
- </Style>
- <Style id="4">
- <Font size="12"/>
- <Borders>
- <Border position="left" lineStyle="NullLine"/>
- <Border position="top" lineStyle="NullLine"/>
- <Border position="right" lineStyle="NullLine"/>
- <Border position="bottom" lineStyle="NullLine"/>
- </Borders>
- </Style>
- <Style id="9">
- <Borders>
- <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="top" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000"/>
- </Borders>
- <Alignment wrapText="false"/>
- <NumberFormat>0.0000;-0.0000</NumberFormat>
- </Style>
- <Style id="8">
- <Borders>
- <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="top" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000"/>
- <Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000"/>
- </Borders>
- <Alignment wrapText="false"/>
- <NumberFormat>#,##0.00;-#,##0.00</NumberFormat>
- </Style>
- </Styles>
- <Report type="r1-print" version="6.2.0">
- <Page id="page1" width="1720" height="2470">
- <Sub-objects>
- <PrintDataGrid id="dataGrid2" styleId="0" x="0" y="1" horizontalFill="true">
- <Script><![CDATA[secondBirth();]]></Script>
- <Data dataSource="AssureBillTDQuery"/>
- <Col width="254" id="column17"/>
- <Col width="293" id="column19"/>
- <Col width="308" id="column7"/>
- <Col width="320" id="column8"/>
- <Col width="351" id="column9"/>
- <Col width="194" id="column10"/>
- <TR height="1421" type="normal" displayEveryPage="true" id="row25" styleId="1">
- <TD id="cell63" styleId="2">
- <Sub-objects>
- <PrintLayoutGrid id="layoutGrid1" styleId="3" x="0" y="0" horizontalFill="true">
- <Data/>
- <Col width="302" id="column2"/>
- <Col width="550" id="column3"/>
- <Col width="301" id="column4"/>
- <Col width="565" id="column6"/>
- <TR height="127" id="row21" styleId="1">
- <TD id="cell50" styleId="4">
- <Value type="text"><![CDATA[Guarantee Note]]></Value>
- </TD>
- <TD id="cell51" styleId="5"/>
- <TD id="cell52" styleId="5"/>
- <TD id="cell54" styleId="6"/>
- </TR>
- <TR height="74" id="row17" styleId="1">
- <TD id="cell56" styleId="7">
- <Value type="text"><![CDATA[Guarantee Note No.]]></Value>
- </TD>
- <TD id="cell57" styleId="7">
- <Value type="field" dataSource="AssureBillTDQuery">number</Value>
- </TD>
- <TD id="cell55" styleId="7">
- <Value type="text"><![CDATA[Guarantor]]></Value>
- </TD>
- <TD id="cell61" styleId="7">
- <Value type="field" dataSource="AssureBillTDQuery">company.name</Value>
- </TD>
- </TR>
- <TR height="74" id="row19" styleId="1">
- <TD id="cell1" styleId="7">
- <Value type="text"><![CDATA[Relation with Guaranteed Unit]]></Value>
- </TD>
- <TD id="cell2" styleId="7">
- <Value type="field" dataSource="AssureBillTDQuery">unionType</Value>
- </TD>
- <TD id="cell3" styleId="7">
- <Value type="text"><![CDATA[Warrantee Name]]></Value>
- </TD>
- <TD id="cell62" styleId="7">
- <Value type="field" dataSource="AssureBillTDQuery">assuredCompany</Value>
- </TD>
- </TR>
- <TR height="74" id="row18" styleId="1">
- <TD id="cell4" styleId="7">
- <Value type="text"><![CDATA[Bank]]></Value>
- </TD>
- <TD id="cell5" styleId="7">
- <Value type="field" dataSource="AssureBillTDQuery">bank.name</Value>
- </TD>
- <TD id="cell6" styleId="7"/>
- <TD id="cell64" styleId="7"/>
- </TR>
- <TR height="74" id="row20" styleId="1">
- <TD id="cell7" styleId="7">
- <Value type="text"><![CDATA[Guarantee Type]]></Value>
- </TD>
- <TD id="cell8" styleId="7">
- <Value type="field" dataSource="AssureBillTDQuery">assureType.name</Value>
- </TD>
- <TD id="cell9" styleId="7">
- <Value type="text"><![CDATA[Contract Amount (Original Currency)]]></Value>
- </TD>
- <TD id="cell65" styleId="8">
- <Value type="field" dataSource="AssureBillTDQuery">contactAmount</Value>
- </TD>
- </TR>
- <TR height="74" id="row1" styleId="1">
- <TD id="cell10" styleId="7">
- <Value type="text"><![CDATA[Currency]]></Value>
- </TD>
- <TD id="cell11" styleId="7">
- <Value type="field" dataSource="AssureBillTDQuery">currency.name</Value>
- </TD>
- <TD id="cell12" styleId="7">
- <Value type="text"><![CDATA[Exchange Rate]]></Value>
- </TD>
- <TD id="cell66" styleId="9">
- <Value type="field" dataSource="AssureBillTDQuery">exRate</Value>
- </TD>
- </TR>
- <TR height="74" id="row2" styleId="1">
- <TD id="cell13" styleId="7">
- <Value type="text"><![CDATA[Contract Amount (Converted to Functional Currency)]]></Value>
- </TD>
- <TD id="cell14" styleId="8">
- <Value type="field" dataSource="AssureBillTDQuery">contactLocalAmt</Value>
- </TD>
- <TD id="cell15" styleId="7">
- <Value type="text"><![CDATA[Guarantee Ratio]]></Value>
- </TD>
- <TD id="cell67" styleId="10">
- <Value type="field" dataSource="AssureBillTDQuery">assurePercent</Value>
- </TD>
- </TR>
- <TR height="74" id="row3" styleId="1">
- <TD id="cell16" styleId="7">
- <Value type="text"><![CDATA[Guarantee Limit (Original Currency)]]></Value>
- </TD>
- <TD id="cell17" styleId="8">
- <Value type="field" dataSource="AssureBillTDQuery">assureLimitAmt</Value>
- </TD>
- <TD id="cell18" styleId="7">
- <Value type="text"><![CDATA[Guarantee Limit (Converted to Functional Currency)]]></Value>
- </TD>
- <TD id="cell68" styleId="8">
- <Value type="field" dataSource="AssureBillTDQuery">asLocalLimitAmt</Value>
- </TD>
- </TR>
- <TR height="74" id="row4" styleId="1">
- <TD id="cell19" styleId="7">
- <Value type="text"><![CDATA[Guarantee Fee]]></Value>
- </TD>
- <TD id="cell20" styleId="8">
- <Value type="field" dataSource="AssureBillTDQuery">assureFee</Value>
- </TD>
- <TD id="cell21" styleId="7">
- <Value type="text"><![CDATA[Guarantee Security Deposit]]></Value>
- </TD>
- <TD id="cell69" styleId="8">
- <Value type="field" dataSource="AssureBillTDQuery">assureCfgFee</Value>
- </TD>
- </TR>
- <TR height="74" id="row5" styleId="1">
- <TD id="cell22" styleId="7">
- <Value type="text"><![CDATA[Start Date]]></Value>
- </TD>
- <TD id="cell23" styleId="7">
- <Value type="field" dataSource="AssureBillTDQuery">beginDate</Value>
- </TD>
- <TD id="cell24" styleId="7">
- <Value type="text"><![CDATA[Maturity Date]]></Value>
- </TD>
- <TD id="cell70" styleId="7">
- <Value type="field" dataSource="AssureBillTDQuery">endDate</Value>
- </TD>
- </TR>
- <TR height="74" id="row6" styleId="1">
- <TD id="cell25" styleId="7">
- <Value type="text"><![CDATA[Terms]]></Value>
- </TD>
- <TD id="cell26" styleId="11">
- <Value type="field" dataSource="AssureBillTDQuery">horizon</Value>
- </TD>
- <TD id="cell27" styleId="7">
- <Value type="text"><![CDATA[Item]]></Value>
- </TD>
- <TD id="cell71" styleId="7">
- <Value type="field" dataSource="AssureBillTDQuery">project.name</Value>
- </TD>
- </TR>
- <TR height="74" id="row7" styleId="1">
- <TD id="cell28" styleId="7">
- <Value type="text"><![CDATA[Remarks]]></Value>
- </TD>
- <TD id="cell29" styleId="7">
- <Value type="field" dataSource="AssureBillTDQuery">description</Value>
- </TD>
- <TD id="cell30" styleId="7"/>
- <TD id="cell72" styleId="7"/>
- </TR>
- <TR height="74" id="row8" styleId="1">
- <TD id="cell31" styleId="12">
- <Value type="text"><![CDATA[De-Guarantee Status]]></Value>
- </TD>
- <TD id="cell32" styleId="7"/>
- <TD id="cell33" styleId="7"/>
- <TD id="cell73" styleId="7"/>
- </TR>
- <TR height="74" id="row9" styleId="1">
- <TD id="cell34" styleId="7">
- <Value type="text"><![CDATA[De-Guaranteed by]]></Value>
- </TD>
- <TD id="cell35" styleId="7">
- <Value type="field" dataSource="AssureBillTDQuery">antiAssurer</Value>
- </TD>
- <TD id="cell36" styleId="7"/>
- <TD id="cell74" styleId="7"/>
- </TR>
- <TR height="74" id="row10" styleId="1">
- <TD id="cell37" styleId="7">
- <Value type="text"><![CDATA[Guarantee Name]]></Value>
- </TD>
- <TD id="cell38" styleId="7">
- <Value type="field" dataSource="AssureBillTDQuery">assureArticle</Value>
- </TD>
- <TD id="cell39" styleId="7"/>
- <TD id="cell75" styleId="7"/>
- </TR>
- <TR height="74" id="row11" styleId="1">
- <TD id="cell40" styleId="7">
- <Value type="text"><![CDATA[De-Guaranteed Amount]]></Value>
- </TD>
- <TD id="cell41" styleId="8">
- <Value type="field" dataSource="AssureBillTDQuery">antiAssAmount</Value>
- </TD>
- <TD id="cell42" styleId="7">
- <Value type="text"><![CDATA[Mortgage Value]]></Value>
- </TD>
- <TD id="cell76" styleId="8">
- <Value type="field" dataSource="AssureBillTDQuery">antiAssValue</Value>
- </TD>
- </TR>
- <TR height="30" id="row12" styleId="1">
- <TD id="cell43" styleId="2"/>
- <TD id="cell44" styleId="1"/>
- <TD id="cell45" styleId="1"/>
- <TD id="cell77" styleId="1"/>
- </TR>
- <TR height="75" id="row13" styleId="1">
- <TD id="cell78" styleId="13">
- <Value type="text"><![CDATA[Guaranteed Transaction Balance (Translated to Functional Currency)]]></Value>
- </TD>
- <TD id="cell80" styleId="8">
- <Value type="field" dataSource="AssureBillTDQuery">bizLocalBalance</Value>
- </TD>
- <TD id="cell81" styleId="7">
- <Value type="text"><![CDATA[Guarantee Responsibility]]></Value>
- </TD>
- <TD id="cell82" styleId="8">
- <Value type="field" dataSource="AssureBillTDQuery">assureResAmount</Value>
- </TD>
- </TR>
- <TR height="75" id="row14" styleId="1">
- <TD id="cell46" styleId="7">
- <Value type="text"><![CDATA[Guaranteed Business Start Date]]></Value>
- </TD>
- <TD id="cell47" styleId="7">
- <Value type="field" dataSource="AssureBillTDQuery">assureBeginDate</Value>
- </TD>
- <TD id="cell48" styleId="7">
- <Value type="text"><![CDATA[Guaranteed Business End Date]]></Value>
- </TD>
- <TD id="cell79" styleId="7">
- <Value type="field" dataSource="AssureBillTDQuery">assureEndDate</Value>
- </TD>
- </TR>
- <MergeBlocks>
- <Block left="0" right="3" top="0" bottom="0"/>
- <Block left="1" right="3" top="3" bottom="3"/>
- <Block left="1" right="3" top="11" bottom="11"/>
- <Block left="0" right="3" top="12" bottom="12"/>
- <Block left="1" right="3" top="13" bottom="13"/>
- <Block left="1" right="3" top="14" bottom="14"/>
- <Block left="0" right="3" top="16" bottom="16"/>
- </MergeBlocks>
- </PrintLayoutGrid>
- </Sub-objects>
- </TD>
- <TD id="cell93" styleId="2">
- <Value type="text"><![CDATA[Task Name]]></Value>
- </TD>
- <TD id="cell105" styleId="2">
- <Value type="text"><![CDATA[Approval Result]]></Value>
- </TD>
- <TD id="cell106" styleId="2">
- <Value type="text"><![CDATA[Processing Policy]]></Value>
- </TD>
- <TD id="cell107" styleId="2">
- <Value type="text"><![CDATA[Approved On]]></Value>
- </TD>
- <TD id="cell108" styleId="2">
- <Value type="text"><![CDATA[Approval Comments]]></Value>
- </TD>
- </TR>
- <TR height="78" type="group" group="g0" displayEveryPage="true" id="row22" styleId="1">
- <TD id="cell111" styleId="2">
- <Value type="text"><![CDATA[Reviewed by]]></Value>
- </TD>
- <TD id="cell112" styleId="2">
- <Value type="text"><![CDATA[Task Name]]></Value>
- </TD>
- <TD id="cell113" styleId="2">
- <Value type="text"><![CDATA[Approval Result]]></Value>
- </TD>
- <TD id="cell114" styleId="2">
- <Value type="text"><![CDATA[Processing Policy]]></Value>
- </TD>
- <TD id="cell115" styleId="2">
- <Value type="text"><![CDATA[Approved On]]></Value>
- </TD>
- <TD id="cell116" styleId="2">
- <Value type="text"><![CDATA[Approval Comments]]></Value>
- </TD>
- </TR>
- <TR height="78" type="detail" id="row26" styleId="1">
- <TD id="cell109" styleId="13">
- <Value type="field">MultiApprove.name</Value>
- </TD>
- <TD id="cell91" styleId="13">
- <Value type="field">MultiApprove.actdefName</Value>
- </TD>
- <TD id="cell94" styleId="13">
- <Script><![CDATA[if(getValue()=="true"){
- setValue("同意")
- }
- if(getValue()=="false"){
- setValue("不同意")
- }
- ]]></Script>
- <Value type="field">MultiApprove.isPass</Value>
- </TD>
- <TD id="cell95" styleId="13">
- <Value type="field">MultiApprove.handlerOpinion</Value>
- </TD>
- <TD id="cell96" styleId="14">
- <Value type="field">MultiApprove.createTime</Value>
- </TD>
- <TD id="cell97" styleId="13">
- <Value type="field">MultiApprove.opinion</Value>
- </TD>
- </TR>
- <TR height="78" type="group" group="g0" displayEveryPage="true" id="row16" styleId="1">
- <TD id="cell53" styleId="2">
- <Sub-objects>
- <PrintLayoutGrid id="layoutGrid3" styleId="1" x="0" y="0" horizontalFill="true" verticalFill="true">
- <Data/>
- <Col width="253" id="column1"/>
- <Col width="297" id="column11"/>
- <Col width="305" id="column18"/>
- <Col width="321" id="column20"/>
- <Col width="353" id="column21"/>
- <Col width="189" id="column22"/>
- <TR height="76" id="row15">
- <TD id="cell49" styleId="2">
- <Value type="text"><![CDATA[Doc Creating Unit]]></Value>
- </TD>
- <TD id="cell84" styleId="2">
- <Value type="field" dataSource="AssureBillTDQuery">tailorCompany.name</Value>
- </TD>
- <TD id="cell85" styleId="2">
- <Value type="text"><![CDATA[Created by]]></Value>
- </TD>
- <TD id="cell125" styleId="2">
- <Value type="field" dataSource="AssureBillTDQuery">creator.name</Value>
- </TD>
- <TD id="cell129" styleId="2">
- <Value type="text"><![CDATA[Created on]]></Value>
- </TD>
- <TD id="cell133" styleId="15">
- <Value type="field" dataSource="AssureBillTDQuery">createTime</Value>
- </TD>
- </TR>
- </PrintLayoutGrid>
- </Sub-objects>
- </TD>
- <TD id="cell87" styleId="2"/>
- <TD id="cell88" styleId="2"/>
- <TD id="cell90" styleId="2"/>
- <TD id="cell92" styleId="2"/>
- <TD id="cell110" styleId="2"/>
- </TR>
- <MergeBlocks>
- <Block left="0" right="5" top="0" bottom="0"/>
- <Block left="0" right="5" top="3" bottom="3"/>
- </MergeBlocks>
- <Groups>
- <Group id="g0" according="field" dividePage="true">billId</Group>
- </Groups>
- </PrintDataGrid>
- </Sub-objects>
- </Page>
- </Report>
- <PrintInfo>
- <PaperSetup>
- <Paper>iso-a4</Paper>
- <Orientation>PORTRAIT</Orientation>
- <PageMargin left="190" right="190" top="250" bottom="250"/>
- <Header height="150" margin="100"/>
- <Footer height="150" margin="100"/>
- </PaperSetup>
- <PrinterSetup>
- <DynamicPaper>false</DynamicPaper>
- <EconomizePaper>false</EconomizePaper>
- </PrinterSetup>
- <PreviewSetup>
- <BackgroundPicture>false</BackgroundPicture>
- </PreviewSetup>
- </PrintInfo>
- </DocRoot>
|